CREATE TABLE [dbo].[DeferredConversionWork]
(
[DeferredConversionWorkKey] [uniqueidentifier] NOT NULL CONSTRAINT [DF_DeferredConversionWork_DeferredConversionWorkKey] DEFAULT (newid()),
[InvoiceKey] [uniqueidentifier] NULL,
[InvoiceNumber] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[FinancialEntityCode] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[TargetGLAccountCode] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[AmountConverted] [decimal] (18, 4) NOT NULL,
[OrganizationKey] [uniqueidentifier] NULL,
[InvoiceLineKey] [uniqueidentifier] NULL,
[InvoiceLineNumber] [int] NULL,
[DeferredGLAccountCode] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[DeferredConversionWork] ADD CONSTRAINT [PK_DeferredConversionWork] PRIMARY KEY CLUSTERED ([DeferredConversionWorkKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_DeferredConversionWork_OrganizationKey] ON [dbo].[DeferredConversionWork] ([OrganizationKey]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[DeferredConversionWork] ADD CONSTRAINT [FK_DeferredConversionWork_OrganizationMain] FOREIGN KEY ([OrganizationKey]) REFERENCES [dbo].[OrganizationMain] ([OrganizationKey])
GO